home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
C/C++ Users Group Library 1996 July
/
C-C++ Users Group Library July 1996.iso
/
listings
/
v_02_08
/
2n08061a
< prev
next >
Wrap
Text File
|
1991-05-12
|
377b
|
13 lines
CREATE VIEW appview(loan#, region#, appdate, funddate)
AS SELECT loan#, region#, appdate, CAST DATE AS NULL
FROM Loans
WHERE appdate BETWEEN 1991-Apr-01 AND 1991-Apr-30;
CREATE VIEW fundview(loan#, region#, appdate, funddate)
AS SELECT loan#, region#, CAST DATE AS NULL, funddate
FROM Loans
WHERE funddate BETWEEN 1991-Apr-01 AND 1991-Apr-30;